<?php

/*
 * Following code will create a new product row
 * All product details are read from HTTP Post Request
 */

// array for JSON response
$response = array();

// check for required fields
if (isset($_POST['user_id']) && isset($_POST['id_level'])&& isset($_POST['rate'])&& isset($_POST['score'])) {
    
    $user_id = $_POST['user_id'];
    $id_level = $_POST['id_level'];
	$rate = $_POST['rate'];
	$score = $_POST['score'];

    // include db connect class
    require_once __DIR__ . '/db_connect.php';

    // connecting to db
    $db = new DB_CONNECT();

    // mysql inserting a new row
    $result = mysql_query("INSERT INTO game(user_id, id_level, rate, score) VALUES('$user_id', '$id_level', '$rate', '$score')");

    // check if row inserted or not
    if ($result) {
        // successfully inserted into database
        $response["responseCode"] = 1;
        $response["responseMessage"] = "Game successfully created.";

        // echoing JSON response
        echo json_encode($response);
    } else {
        // failed to insert row
        $response["responseCode"] = -1;
        $response["responseMessage"] = "Oops! An error occurred.";
        
        // echoing JSON response
        echo json_encode($response);
    }
} else {
    // required field is missing
    $response["responseCode"] = -1;
    $response["responseMessage"] = "Required field(s) is missing";

    // echoing JSON response
    echo json_encode($response);
}
?>